RetrieveClientSql

/ Assembly List / LJCDBClientLib / ObjectManager`2 / RetrieveClientSql

Namespace - LJCDBClientLib

Parameters

sql - The client SQL statement.

Returns

The data object.

Syntax

C#
public TData RetrieveClientSql(String sql)

Executes a "Retrieve" client SQL statement. (E)

Example

C#
// Selects a record with an SQL statement. private static void RetrieveClientSql(ObjectManager<Person, Persons> personManager) { Person retValue = null; StringBuilder builder = new StringBuilder(64); builder.AppendLine("select * from PersonTest"); builder.AppendLine("where Name = 'TestName'"); string sql = builder.ToString(); retValue = personManager.RetrieveClientSql(sql); return retValue; }

// Selects a record with an SQL statement.
private static void RetrieveClientSql(ObjectManager<Person, Persons> personManager)
{
  Person retValue = null;

  StringBuilder builder = new StringBuilder(64);
  builder.AppendLine("select * from PersonTest");
  builder.AppendLine("where Name = 'TestName'");
  string sql = builder.ToString();

  retValue = personManager.RetrieveClientSql(sql);
  return retValue;
}